Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 135617 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 26.9 MiB |
| Average record size in memory | 208.0 B |
Variable types
| NUM | 25 |
|---|---|
| BOOL | 1 |
Reproduction
| Analysis started | 2021-05-24 04:30:54.447773 |
|---|---|
| Analysis finished | 2021-05-24 04:34:03.010317 |
| Duration | 3 minutes and 8.56 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
mainpage is highly skewed (γ1 = 138.5520519) | Skewed |
main_learnpark is highly skewed (γ1 = 54.91676128) | Skewed |
evaulationcenter is highly skewed (γ1 = 52.66970727) | Skewed |
coupon_visit is highly skewed (γ1 = 260.8225025) | Skewed |
click_dialog is highly skewed (γ1 = 32.21479429) | Skewed |
user_id has unique values | Unique |
main_home has 12028 (8.9%) zeros | Zeros |
main_home2 has 7760 (5.7%) zeros | Zeros |
mainpage has 27625 (20.4%) zeros | Zeros |
schoolreportpage has 61178 (45.1%) zeros | Zeros |
main_mime has 94339 (69.6%) zeros | Zeros |
lightcoursetab has 79098 (58.3%) zeros | Zeros |
main_learnpark has 93023 (68.6%) zeros | Zeros |
partnergamebarrierspage has 127206 (93.8%) zeros | Zeros |
evaulationcenter has 90610 (66.8%) zeros | Zeros |
coupon_visit has 125698 (92.7%) zeros | Zeros |
progress_bar has 113698 (83.8%) zeros | Zeros |
ppt has 47873 (35.3%) zeros | Zeros |
task has 37292 (27.5%) zeros | Zeros |
video_play has 40981 (30.2%) zeros | Zeros |
video_read has 43206 (31.9%) zeros | Zeros |
next_nize has 46612 (34.4%) zeros | Zeros |
answer_task has 36105 (26.6%) zeros | Zeros |
chapter_module has 27125 (20.0%) zeros | Zeros |
course_tab has 37758 (27.8%) zeros | Zeros |
slide_subscribe has 29784 (22.0%) zeros | Zeros |
baby_info has 29701 (21.9%) zeros | Zeros |
click_notunlocked has 67709 (49.9%) zeros | Zeros |
share has 53206 (39.2%) zeros | Zeros |
click_dialog has 29313 (21.6%) zeros | Zeros |
| Distinct count | 135617 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2000002535200329.5 |
|---|---|
| Minimum | 2000001555945280 |
| Maximum | 2000002948014779 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 2.000001556e+15 |
|---|---|
| 5-th percentile | 2.000002282e+15 |
| Q1 | 2.000002415e+15 |
| median | 2.000002499e+15 |
| Q3 | 2.000002718e+15 |
| 95-th percentile | 2.000002919e+15 |
| Maximum | 2.000002948e+15 |
| Range | 1392069499 |
| Interquartile range (IQR) | 303046960 |
Descriptive statistics
| Standard deviation | 249996404 |
|---|---|
| Coefficient of variation (CV) | 1.249980436e-07 |
| Kurtosis | 3.719889271 |
| Mean | 2.000002535e+15 |
| Median Absolute Deviation (MAD) | 114796193 |
| Skewness | -1.247888558 |
| Sum | -5.466817289e+18 |
| Variance | 6.249820203e+16 |
| Value | Count | Frequency (%) | |
| 2.000002763e+15 | 1 | < 0.1% | |
| 2.000002458e+15 | 1 | < 0.1% | |
| 2.000002739e+15 | 1 | < 0.1% | |
| 2.000002421e+15 | 1 | < 0.1% | |
| 2.000001659e+15 | 1 | < 0.1% | |
| 2.00000244e+15 | 1 | < 0.1% | |
| 2.000002356e+15 | 1 | < 0.1% | |
| 2.000002829e+15 | 1 | < 0.1% | |
| 2.000002421e+15 | 1 | < 0.1% | |
| 2.000002753e+15 | 1 | < 0.1% | |
| Other values (135607) | 135607 | > 99.9% |
| Value | Count | Frequency (%) | |
| 2.000001556e+15 | 1 | < 0.1% | |
| 2.000001557e+15 | 1 | < 0.1% | |
| 2.000001558e+15 | 1 | < 0.1% | |
| 2.000001558e+15 | 1 | < 0.1% | |
| 2.000001558e+15 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 2.000002948e+15 | 1 | < 0.1% | |
| 2.000002947e+15 | 1 | < 0.1% | |
| 2.000002947e+15 | 1 | < 0.1% | |
| 2.000002947e+15 | 1 | < 0.1% | |
| 2.000002947e+15 | 1 | < 0.1% |
| Distinct count | 405 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.53959311885678 |
|---|---|
| Minimum | 0 |
| Maximum | 2172 |
| Zeros | 12028 |
| Zeros (%) | 8.9% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 12 |
| median | 48 |
| Q3 | 87 |
| 95-th percentile | 148 |
| Maximum | 2172 |
| Range | 2172 |
| Interquartile range (IQR) | 75 |
Descriptive statistics
| Standard deviation | 51.76543299 |
|---|---|
| Coefficient of variation (CV) | 0.9155607625 |
| Kurtosis | 42.24666 |
| Mean | 56.53959312 |
| Median Absolute Deviation (MAD) | 37 |
| Skewness | 2.312317626 |
| Sum | 7667730 |
| Variance | 2679.660052 |
| Value | Count | Frequency (%) | |
| 0 | 12028 | 8.9% | |
| 1 | 2702 | 2.0% | |
| 2 | 2424 | 1.8% | |
| 3 | 2364 | 1.7% | |
| 4 | 2166 | 1.6% | |
| 5 | 2113 | 1.6% | |
| 6 | 1854 | 1.4% | |
| 7 | 1753 | 1.3% | |
| 8 | 1554 | 1.1% | |
| 9 | 1446 | 1.1% | |
| Other values (395) | 105213 | 77.6% |
| Value | Count | Frequency (%) | |
| 0 | 12028 | 8.9% | |
| 1 | 2702 | 2.0% | |
| 2 | 2424 | 1.8% | |
| 3 | 2364 | 1.7% | |
| 4 | 2166 | 1.6% |
| Value | Count | Frequency (%) | |
| 2172 | 1 | < 0.1% | |
| 1643 | 1 | < 0.1% | |
| 1565 | 1 | < 0.1% | |
| 1476 | 1 | < 0.1% | |
| 1353 | 1 | < 0.1% |
| Distinct count | 467 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 47.509795969531844 |
|---|---|
| Minimum | 0 |
| Maximum | 2685 |
| Zeros | 7760 |
| Zeros (%) | 5.7% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 14 |
| median | 35 |
| Q3 | 66 |
| 95-th percentile | 136 |
| Maximum | 2685 |
| Range | 2685 |
| Interquartile range (IQR) | 52 |
Descriptive statistics
| Standard deviation | 48.7259156 |
|---|---|
| Coefficient of variation (CV) | 1.02559724 |
| Kurtosis | 126.5376975 |
| Mean | 47.50979597 |
| Median Absolute Deviation (MAD) | 24 |
| Skewness | 4.637230009 |
| Sum | 6443136 |
| Variance | 2374.214851 |
| Value | Count | Frequency (%) | |
| 0 | 7760 | 5.7% | |
| 2 | 3765 | 2.8% | |
| 9 | 2198 | 1.6% | |
| 7 | 2143 | 1.6% | |
| 12 | 2137 | 1.6% | |
| 6 | 1968 | 1.5% | |
| 17 | 1917 | 1.4% | |
| 14 | 1894 | 1.4% | |
| 11 | 1887 | 1.4% | |
| 15 | 1881 | 1.4% | |
| Other values (457) | 108067 | 79.7% |
| Value | Count | Frequency (%) | |
| 0 | 7760 | 5.7% | |
| 1 | 19 | < 0.1% | |
| 2 | 3765 | 2.8% | |
| 3 | 1302 | 1.0% | |
| 4 | 1752 | 1.3% |
| Value | Count | Frequency (%) | |
| 2685 | 1 | < 0.1% | |
| 2481 | 1 | < 0.1% | |
| 1327 | 1 | < 0.1% | |
| 966 | 1 | < 0.1% | |
| 913 | 1 | < 0.1% |
| Distinct count | 112 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.243914848433456 |
|---|---|
| Minimum | 0 |
| Maximum | 2847 |
| Zeros | 27625 |
| Zeros (%) | 20.4% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 7 |
| 95-th percentile | 18 |
| Maximum | 2847 |
| Range | 2847 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 11.05981639 |
|---|---|
| Coefficient of variation (CV) | 2.109076274 |
| Kurtosis | 33461.95222 |
| Mean | 5.243914848 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 138.5520519 |
| Sum | 711164 |
| Variance | 122.3195386 |
| Value | Count | Frequency (%) | |
| 0 | 27625 | 20.4% | |
| 1 | 18780 | 13.8% | |
| 2 | 14767 | 10.9% | |
| 3 | 11884 | 8.8% | |
| 4 | 9745 | 7.2% | |
| 5 | 8220 | 6.1% | |
| 6 | 6771 | 5.0% | |
| 7 | 5783 | 4.3% | |
| 8 | 4854 | 3.6% | |
| 9 | 4065 | 3.0% | |
| Other values (102) | 23123 | 17.1% |
| Value | Count | Frequency (%) | |
| 0 | 27625 | 20.4% | |
| 1 | 18780 | 13.8% | |
| 2 | 14767 | 10.9% | |
| 3 | 11884 | 8.8% | |
| 4 | 9745 | 7.2% |
| Value | Count | Frequency (%) | |
| 2847 | 1 | < 0.1% | |
| 1266 | 1 | < 0.1% | |
| 579 | 1 | < 0.1% | |
| 382 | 1 | < 0.1% | |
| 317 | 1 | < 0.1% |
| Distinct count | 80 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.7873422948450415 |
|---|---|
| Minimum | 0 |
| Maximum | 482 |
| Zeros | 61178 |
| Zeros (%) | 45.1% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 6 |
| 95-th percentile | 15 |
| Maximum | 482 |
| Range | 482 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 6.174570164 |
|---|---|
| Coefficient of variation (CV) | 1.630317432 |
| Kurtosis | 606.3301326 |
| Mean | 3.787342295 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 11.18925298 |
| Sum | 513628 |
| Variance | 38.12531672 |
| Value | Count | Frequency (%) | |
| 0 | 61178 | 45.1% | |
| 2 | 12955 | 9.6% | |
| 4 | 8816 | 6.5% | |
| 1 | 7961 | 5.9% | |
| 6 | 6538 | 4.8% | |
| 8 | 5409 | 4.0% | |
| 3 | 5312 | 3.9% | |
| 10 | 4600 | 3.4% | |
| 5 | 3695 | 2.7% | |
| 12 | 2847 | 2.1% | |
| Other values (70) | 16306 | 12.0% |
| Value | Count | Frequency (%) | |
| 0 | 61178 | 45.1% | |
| 1 | 7961 | 5.9% | |
| 2 | 12955 | 9.6% | |
| 3 | 5312 | 3.9% | |
| 4 | 8816 | 6.5% |
| Value | Count | Frequency (%) | |
| 482 | 1 | < 0.1% | |
| 419 | 1 | < 0.1% | |
| 382 | 1 | < 0.1% | |
| 297 | 1 | < 0.1% | |
| 286 | 1 | < 0.1% |
| Distinct count | 54 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7735018471135625 |
|---|---|
| Minimum | 0 |
| Maximum | 117 |
| Zeros | 94339 |
| Zeros (%) | 69.6% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 4 |
| Maximum | 117 |
| Range | 117 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.977206222 |
|---|---|
| Coefficient of variation (CV) | 2.556175179 |
| Kurtosis | 190.5772531 |
| Mean | 0.7735018471 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.249566965 |
| Sum | 104900 |
| Variance | 3.909344445 |
| Value | Count | Frequency (%) | |
| 0 | 94339 | 69.6% | |
| 1 | 19632 | 14.5% | |
| 2 | 9118 | 6.7% | |
| 3 | 4547 | 3.4% | |
| 4 | 2689 | 2.0% | |
| 5 | 1551 | 1.1% | |
| 6 | 1045 | 0.8% | |
| 7 | 766 | 0.6% | |
| 8 | 451 | 0.3% | |
| 9 | 363 | 0.3% | |
| Other values (44) | 1116 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 94339 | 69.6% | |
| 1 | 19632 | 14.5% | |
| 2 | 9118 | 6.7% | |
| 3 | 4547 | 3.4% | |
| 4 | 2689 | 2.0% |
| Value | Count | Frequency (%) | |
| 117 | 1 | < 0.1% | |
| 76 | 1 | < 0.1% | |
| 69 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% |
| Distinct count | 63 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1277937131775515 |
|---|---|
| Minimum | 0 |
| Maximum | 271 |
| Zeros | 79098 |
| Zeros (%) | 58.3% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 271 |
| Range | 271 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 2.556153522 |
|---|---|
| Coefficient of variation (CV) | 2.266508043 |
| Kurtosis | 1004.898256 |
| Mean | 1.127793713 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.77574841 |
| Sum | 152948 |
| Variance | 6.533920829 |
| Value | Count | Frequency (%) | |
| 0 | 79098 | 58.3% | |
| 1 | 25374 | 18.7% | |
| 2 | 12479 | 9.2% | |
| 3 | 6868 | 5.1% | |
| 4 | 3878 | 2.9% | |
| 5 | 2300 | 1.7% | |
| 6 | 1526 | 1.1% | |
| 7 | 1022 | 0.8% | |
| 8 | 737 | 0.5% | |
| 9 | 499 | 0.4% | |
| Other values (53) | 1836 | 1.4% |
| Value | Count | Frequency (%) | |
| 0 | 79098 | 58.3% | |
| 1 | 25374 | 18.7% | |
| 2 | 12479 | 9.2% | |
| 3 | 6868 | 5.1% | |
| 4 | 3878 | 2.9% |
| Value | Count | Frequency (%) | |
| 271 | 1 | < 0.1% | |
| 92 | 1 | < 0.1% | |
| 87 | 1 | < 0.1% | |
| 77 | 1 | < 0.1% | |
| 74 | 1 | < 0.1% |
| Distinct count | 64 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.0565342103128663 |
|---|---|
| Minimum | 0 |
| Maximum | 618 |
| Zeros | 93023 |
| Zeros (%) | 68.6% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 5 |
| Maximum | 618 |
| Range | 618 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 3.252269818 |
|---|---|
| Coefficient of variation (CV) | 3.078243739 |
| Kurtosis | 9609.689739 |
| Mean | 1.05653421 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 54.91676128 |
| Sum | 143284 |
| Variance | 10.57725897 |
| Value | Count | Frequency (%) | |
| 0 | 93023 | 68.6% | |
| 1 | 16455 | 12.1% | |
| 2 | 8881 | 6.5% | |
| 3 | 5089 | 3.8% | |
| 4 | 3346 | 2.5% | |
| 5 | 2235 | 1.6% | |
| 6 | 1531 | 1.1% | |
| 7 | 1071 | 0.8% | |
| 8 | 868 | 0.6% | |
| 9 | 622 | 0.5% | |
| Other values (54) | 2496 | 1.8% |
| Value | Count | Frequency (%) | |
| 0 | 93023 | 68.6% | |
| 1 | 16455 | 12.1% | |
| 2 | 8881 | 6.5% | |
| 3 | 5089 | 3.8% | |
| 4 | 3346 | 2.5% |
| Value | Count | Frequency (%) | |
| 618 | 1 | < 0.1% | |
| 131 | 1 | < 0.1% | |
| 88 | 1 | < 0.1% | |
| 79 | 1 | < 0.1% | |
| 76 | 1 | < 0.1% |
| Distinct count | 154 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8198972105267038 |
|---|---|
| Minimum | 0 |
| Maximum | 323 |
| Zeros | 127206 |
| Zeros (%) | 93.8% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3 |
| Maximum | 323 |
| Range | 323 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 5.941075734 |
|---|---|
| Coefficient of variation (CV) | 7.246122633 |
| Kurtosis | 437.9941842 |
| Mean | 0.8198972105 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.54597499 |
| Sum | 111192 |
| Variance | 35.29638088 |
| Value | Count | Frequency (%) | |
| 0 | 127206 | 93.8% | |
| 2 | 829 | 0.6% | |
| 1 | 771 | 0.6% | |
| 3 | 738 | 0.5% | |
| 5 | 670 | 0.5% | |
| 4 | 640 | 0.5% | |
| 6 | 530 | 0.4% | |
| 7 | 417 | 0.3% | |
| 8 | 357 | 0.3% | |
| 9 | 315 | 0.2% | |
| Other values (144) | 3144 | 2.3% |
| Value | Count | Frequency (%) | |
| 0 | 127206 | 93.8% | |
| 1 | 771 | 0.6% | |
| 2 | 829 | 0.6% | |
| 3 | 738 | 0.5% | |
| 4 | 640 | 0.5% |
| Value | Count | Frequency (%) | |
| 323 | 1 | < 0.1% | |
| 285 | 1 | < 0.1% | |
| 269 | 1 | < 0.1% | |
| 252 | 2 | < 0.1% | |
| 222 | 1 | < 0.1% |
| Distinct count | 96 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.1187904171305956 |
|---|---|
| Minimum | 0 |
| Maximum | 1153 |
| Zeros | 90610 |
| Zeros (%) | 66.8% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 2 |
| 95-th percentile | 11 |
| Maximum | 1153 |
| Range | 1153 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 6.249540029 |
|---|---|
| Coefficient of variation (CV) | 2.949579146 |
| Kurtosis | 8741.112266 |
| Mean | 2.118790417 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 52.66970727 |
| Sum | 287344 |
| Variance | 39.05675058 |
| Value | Count | Frequency (%) | |
| 0 | 90610 | 66.8% | |
| 1 | 9413 | 6.9% | |
| 3 | 6948 | 5.1% | |
| 4 | 4767 | 3.5% | |
| 2 | 4362 | 3.2% | |
| 5 | 3023 | 2.2% | |
| 6 | 2550 | 1.9% | |
| 7 | 2058 | 1.5% | |
| 8 | 1675 | 1.2% | |
| 9 | 1388 | 1.0% | |
| Other values (86) | 8823 | 6.5% |
| Value | Count | Frequency (%) | |
| 0 | 90610 | 66.8% | |
| 1 | 9413 | 6.9% | |
| 2 | 4362 | 3.2% | |
| 3 | 6948 | 5.1% | |
| 4 | 4767 | 3.5% |
| Value | Count | Frequency (%) | |
| 1153 | 1 | < 0.1% | |
| 452 | 1 | < 0.1% | |
| 304 | 1 | < 0.1% | |
| 132 | 1 | < 0.1% | |
| 131 | 1 | < 0.1% |
| Distinct count | 40 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.16481709520192897 |
|---|---|
| Minimum | 0 |
| Maximum | 806 |
| Zeros | 125698 |
| Zeros (%) | 92.7% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 806 |
| Range | 806 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.48996631 |
|---|---|
| Coefficient of variation (CV) | 15.10745173 |
| Kurtosis | 81954.46479 |
| Mean | 0.1648170952 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 260.8225025 |
| Sum | 22352 |
| Variance | 6.199932223 |
| Value | Count | Frequency (%) | |
| 0 | 125698 | 92.7% | |
| 1 | 5512 | 4.1% | |
| 2 | 2180 | 1.6% | |
| 3 | 936 | 0.7% | |
| 4 | 491 | 0.4% | |
| 5 | 246 | 0.2% | |
| 6 | 161 | 0.1% | |
| 7 | 112 | 0.1% | |
| 8 | 65 | < 0.1% | |
| 9 | 45 | < 0.1% | |
| Other values (30) | 171 | 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 125698 | 92.7% | |
| 1 | 5512 | 4.1% | |
| 2 | 2180 | 1.6% | |
| 3 | 936 | 0.7% | |
| 4 | 491 | 0.4% |
| Value | Count | Frequency (%) | |
| 806 | 1 | < 0.1% | |
| 271 | 1 | < 0.1% | |
| 84 | 1 | < 0.1% | |
| 78 | 1 | < 0.1% | |
| 72 | 1 | < 0.1% |
click_buy
Boolean
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.0 MiB |
| 0 | |
|---|---|
| 1 | 2 |
| Value | Count | Frequency (%) | |
| 0 | 135615 | > 99.9% | |
| 1 | 2 | < 0.1% |
| Distinct count | 1783 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 39.17378352271471 |
|---|---|
| Minimum | 0 |
| Maximum | 14878 |
| Zeros | 113698 |
| Zeros (%) | 83.8% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 190 |
| Maximum | 14878 |
| Range | 14878 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 217.8777155 |
|---|---|
| Coefficient of variation (CV) | 5.561824667 |
| Kurtosis | 555.4763282 |
| Mean | 39.17378352 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.15279714 |
| Sum | 5312631 |
| Variance | 47470.69892 |
| Value | Count | Frequency (%) | |
| 0 | 113698 | 83.8% | |
| 1 | 1093 | 0.8% | |
| 2 | 702 | 0.5% | |
| 3 | 537 | 0.4% | |
| 4 | 504 | 0.4% | |
| 5 | 394 | 0.3% | |
| 6 | 367 | 0.3% | |
| 7 | 333 | 0.2% | |
| 8 | 299 | 0.2% | |
| 9 | 271 | 0.2% | |
| Other values (1773) | 17419 | 12.8% |
| Value | Count | Frequency (%) | |
| 0 | 113698 | 83.8% | |
| 1 | 1093 | 0.8% | |
| 2 | 702 | 0.5% | |
| 3 | 537 | 0.4% | |
| 4 | 504 | 0.4% |
| Value | Count | Frequency (%) | |
| 14878 | 1 | < 0.1% | |
| 14010 | 1 | < 0.1% | |
| 12199 | 1 | < 0.1% | |
| 9484 | 1 | < 0.1% | |
| 7426 | 1 | < 0.1% |
| Distinct count | 328 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.76130573600655 |
|---|---|
| Minimum | 0 |
| Maximum | 865 |
| Zeros | 47873 |
| Zeros (%) | 35.3% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 17 |
| Q3 | 36 |
| 95-th percentile | 71 |
| Maximum | 865 |
| Range | 865 |
| Interquartile range (IQR) | 36 |
Descriptive statistics
| Standard deviation | 28.66665343 |
|---|---|
| Coefficient of variation (CV) | 1.206442683 |
| Kurtosis | 36.38347728 |
| Mean | 23.76130574 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 3.314542559 |
| Sum | 3222437 |
| Variance | 821.7770191 |
| Value | Count | Frequency (%) | |
| 0 | 47873 | 35.3% | |
| 34 | 10244 | 7.6% | |
| 9 | 6675 | 4.9% | |
| 25 | 5012 | 3.7% | |
| 17 | 4983 | 3.7% | |
| 8 | 2343 | 1.7% | |
| 43 | 2226 | 1.6% | |
| 42 | 2154 | 1.6% | |
| 36 | 2091 | 1.5% | |
| 26 | 1842 | 1.4% | |
| Other values (318) | 50174 | 37.0% |
| Value | Count | Frequency (%) | |
| 0 | 47873 | 35.3% | |
| 1 | 372 | 0.3% | |
| 2 | 207 | 0.2% | |
| 3 | 334 | 0.2% | |
| 4 | 606 | 0.4% |
| Value | Count | Frequency (%) | |
| 865 | 1 | < 0.1% | |
| 857 | 1 | < 0.1% | |
| 789 | 1 | < 0.1% | |
| 652 | 1 | < 0.1% | |
| 611 | 1 | < 0.1% |
| Distinct count | 160 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16.520362491428067 |
|---|---|
| Minimum | 0 |
| Maximum | 522 |
| Zeros | 37292 |
| Zeros (%) | 27.5% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14 |
| Q3 | 28 |
| 95-th percentile | 44 |
| Maximum | 522 |
| Range | 522 |
| Interquartile range (IQR) | 28 |
Descriptive statistics
| Standard deviation | 16.48727066 |
|---|---|
| Coefficient of variation (CV) | 0.9979969067 |
| Kurtosis | 14.20615462 |
| Mean | 16.52036249 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 1.579989507 |
| Sum | 2240442 |
| Variance | 271.8300939 |
| Value | Count | Frequency (%) | |
| 0 | 37292 | 27.5% | |
| 28 | 4625 | 3.4% | |
| 24 | 4241 | 3.1% | |
| 1 | 4190 | 3.1% | |
| 7 | 3914 | 2.9% | |
| 29 | 3688 | 2.7% | |
| 6 | 3288 | 2.4% | |
| 30 | 3054 | 2.3% | |
| 25 | 3029 | 2.2% | |
| 14 | 2994 | 2.2% | |
| Other values (150) | 65302 | 48.2% |
| Value | Count | Frequency (%) | |
| 0 | 37292 | 27.5% | |
| 1 | 4190 | 3.1% | |
| 2 | 2056 | 1.5% | |
| 3 | 1599 | 1.2% | |
| 4 | 1513 | 1.1% |
| Value | Count | Frequency (%) | |
| 522 | 1 | < 0.1% | |
| 426 | 1 | < 0.1% | |
| 334 | 1 | < 0.1% | |
| 299 | 1 | < 0.1% | |
| 227 | 2 | < 0.1% |
| Distinct count | 402 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.68586534136576 |
|---|---|
| Minimum | 0 |
| Maximum | 1741 |
| Zeros | 40981 |
| Zeros (%) | 30.2% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 14 |
| Q3 | 33 |
| 95-th percentile | 82 |
| Maximum | 1741 |
| Range | 1741 |
| Interquartile range (IQR) | 33 |
Descriptive statistics
| Standard deviation | 34.24833739 |
|---|---|
| Coefficient of variation (CV) | 1.445939884 |
| Kurtosis | 102.1444181 |
| Mean | 23.68586534 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | 5.326410088 |
| Sum | 3212206 |
| Variance | 1172.948614 |
| Value | Count | Frequency (%) | |
| 0 | 40981 | 30.2% | |
| 1 | 2281 | 1.7% | |
| 15 | 2245 | 1.7% | |
| 17 | 2214 | 1.6% | |
| 14 | 2184 | 1.6% | |
| 13 | 2140 | 1.6% | |
| 3 | 2133 | 1.6% | |
| 18 | 2128 | 1.6% | |
| 16 | 2120 | 1.6% | |
| 19 | 2109 | 1.6% | |
| Other values (392) | 75082 | 55.4% |
| Value | Count | Frequency (%) | |
| 0 | 40981 | 30.2% | |
| 1 | 2281 | 1.7% | |
| 2 | 1467 | 1.1% | |
| 3 | 2133 | 1.6% | |
| 4 | 1921 | 1.4% |
| Value | Count | Frequency (%) | |
| 1741 | 1 | < 0.1% | |
| 1343 | 1 | < 0.1% | |
| 1195 | 1 | < 0.1% | |
| 760 | 1 | < 0.1% | |
| 750 | 1 | < 0.1% |
| Distinct count | 231 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.695694492578365 |
|---|---|
| Minimum | 0 |
| Maximum | 2269 |
| Zeros | 43206 |
| Zeros (%) | 31.9% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 17 |
| Q3 | 40 |
| 95-th percentile | 71 |
| Maximum | 2269 |
| Range | 2269 |
| Interquartile range (IQR) | 40 |
Descriptive statistics
| Standard deviation | 27.0902178 |
|---|---|
| Coefficient of variation (CV) | 1.143254856 |
| Kurtosis | 388.2250588 |
| Mean | 23.69569449 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 6.372234185 |
| Sum | 3213539 |
| Variance | 733.8799007 |
| Value | Count | Frequency (%) | |
| 0 | 43206 | 31.9% | |
| 1 | 4232 | 3.1% | |
| 24 | 2157 | 1.6% | |
| 12 | 2002 | 1.5% | |
| 6 | 1795 | 1.3% | |
| 25 | 1792 | 1.3% | |
| 26 | 1731 | 1.3% | |
| 8 | 1661 | 1.2% | |
| 33 | 1657 | 1.2% | |
| 2 | 1616 | 1.2% | |
| Other values (221) | 73768 | 54.4% |
| Value | Count | Frequency (%) | |
| 0 | 43206 | 31.9% | |
| 1 | 4232 | 3.1% | |
| 2 | 1616 | 1.2% | |
| 3 | 891 | 0.7% | |
| 4 | 603 | 0.4% |
| Value | Count | Frequency (%) | |
| 2269 | 1 | < 0.1% | |
| 1254 | 1 | < 0.1% | |
| 706 | 1 | < 0.1% | |
| 704 | 1 | < 0.1% | |
| 458 | 1 | < 0.1% |
| Distinct count | 366 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.03790085313788 |
|---|---|
| Minimum | 0 |
| Maximum | 1271 |
| Zeros | 46612 |
| Zeros (%) | 34.4% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 17 |
| Q3 | 35 |
| 95-th percentile | 73 |
| Maximum | 1271 |
| Range | 1271 |
| Interquartile range (IQR) | 35 |
Descriptive statistics
| Standard deviation | 30.1524556 |
|---|---|
| Coefficient of variation (CV) | 1.308819575 |
| Kurtosis | 85.75198535 |
| Mean | 23.03790085 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 4.916818692 |
| Sum | 3124331 |
| Variance | 909.1705786 |
| Value | Count | Frequency (%) | |
| 0 | 46612 | 34.4% | |
| 28 | 10058 | 7.4% | |
| 7 | 6842 | 5.0% | |
| 21 | 5590 | 4.1% | |
| 14 | 5152 | 3.8% | |
| 35 | 3235 | 2.4% | |
| 36 | 3096 | 2.3% | |
| 29 | 2721 | 2.0% | |
| 9 | 2233 | 1.6% | |
| 37 | 1877 | 1.4% | |
| Other values (356) | 48201 | 35.5% |
| Value | Count | Frequency (%) | |
| 0 | 46612 | 34.4% | |
| 1 | 222 | 0.2% | |
| 2 | 311 | 0.2% | |
| 3 | 107 | 0.1% | |
| 4 | 176 | 0.1% |
| Value | Count | Frequency (%) | |
| 1271 | 1 | < 0.1% | |
| 1261 | 1 | < 0.1% | |
| 948 | 1 | < 0.1% | |
| 942 | 1 | < 0.1% | |
| 843 | 1 | < 0.1% |
| Distinct count | 208 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.389693032584411 |
|---|---|
| Minimum | 0 |
| Maximum | 760 |
| Zeros | 36105 |
| Zeros (%) | 26.6% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 7 |
| Q3 | 19 |
| 95-th percentile | 41 |
| Maximum | 760 |
| Range | 760 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 16.12653072 |
|---|---|
| Coefficient of variation (CV) | 1.301608577 |
| Kurtosis | 63.31032131 |
| Mean | 12.38969303 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 3.964092881 |
| Sum | 1680253 |
| Variance | 260.0649932 |
| Value | Count | Frequency (%) | |
| 0 | 36105 | 26.6% | |
| 3 | 7228 | 5.3% | |
| 6 | 6151 | 4.5% | |
| 1 | 5915 | 4.4% | |
| 9 | 5025 | 3.7% | |
| 12 | 4527 | 3.3% | |
| 2 | 4009 | 3.0% | |
| 18 | 3971 | 2.9% | |
| 7 | 3407 | 2.5% | |
| 15 | 3388 | 2.5% | |
| Other values (198) | 55891 | 41.2% |
| Value | Count | Frequency (%) | |
| 0 | 36105 | 26.6% | |
| 1 | 5915 | 4.4% | |
| 2 | 4009 | 3.0% | |
| 3 | 7228 | 5.3% | |
| 4 | 2942 | 2.2% |
| Value | Count | Frequency (%) | |
| 760 | 1 | < 0.1% | |
| 482 | 1 | < 0.1% | |
| 456 | 1 | < 0.1% | |
| 319 | 1 | < 0.1% | |
| 312 | 1 | < 0.1% |
| Distinct count | 203 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.213542549975298 |
|---|---|
| Minimum | 0 |
| Maximum | 1157 |
| Zeros | 27125 |
| Zeros (%) | 20.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 5 |
| Q3 | 13 |
| 95-th percentile | 38 |
| Maximum | 1157 |
| Range | 1157 |
| Interquartile range (IQR) | 12 |
Descriptive statistics
| Standard deviation | 16.05834722 |
|---|---|
| Coefficient of variation (CV) | 1.572260275 |
| Kurtosis | 514.9955641 |
| Mean | 10.21354255 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 10.62480866 |
| Sum | 1385130 |
| Variance | 257.8705153 |
| Value | Count | Frequency (%) | |
| 0 | 27125 | 20.0% | |
| 1 | 12119 | 8.9% | |
| 2 | 10005 | 7.4% | |
| 3 | 8251 | 6.1% | |
| 4 | 7285 | 5.4% | |
| 5 | 6372 | 4.7% | |
| 6 | 5510 | 4.1% | |
| 7 | 5009 | 3.7% | |
| 8 | 4543 | 3.3% | |
| 9 | 3852 | 2.8% | |
| Other values (193) | 45546 | 33.6% |
| Value | Count | Frequency (%) | |
| 0 | 27125 | 20.0% | |
| 1 | 12119 | 8.9% | |
| 2 | 10005 | 7.4% | |
| 3 | 8251 | 6.1% | |
| 4 | 7285 | 5.4% |
| Value | Count | Frequency (%) | |
| 1157 | 1 | < 0.1% | |
| 1143 | 1 | < 0.1% | |
| 995 | 1 | < 0.1% | |
| 571 | 1 | < 0.1% | |
| 393 | 1 | < 0.1% |
| Distinct count | 327 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.2590530685681 |
|---|---|
| Minimum | 0 |
| Maximum | 1743 |
| Zeros | 37758 |
| Zeros (%) | 27.8% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 4 |
| Q3 | 16 |
| 95-th percentile | 64 |
| Maximum | 1743 |
| Range | 1743 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 27.22827121 |
|---|---|
| Coefficient of variation (CV) | 1.909542736 |
| Kurtosis | 206.8041003 |
| Mean | 14.25905307 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 6.949570579 |
| Sum | 1933770 |
| Variance | 741.3787529 |
| Value | Count | Frequency (%) | |
| 0 | 37758 | 27.8% | |
| 1 | 13440 | 9.9% | |
| 2 | 9551 | 7.0% | |
| 3 | 6176 | 4.6% | |
| 4 | 5385 | 4.0% | |
| 5 | 4250 | 3.1% | |
| 6 | 3879 | 2.9% | |
| 7 | 3083 | 2.3% | |
| 8 | 2947 | 2.2% | |
| 9 | 2492 | 1.8% | |
| Other values (317) | 46656 | 34.4% |
| Value | Count | Frequency (%) | |
| 0 | 37758 | 27.8% | |
| 1 | 13440 | 9.9% | |
| 2 | 9551 | 7.0% | |
| 3 | 6176 | 4.6% | |
| 4 | 5385 | 4.0% |
| Value | Count | Frequency (%) | |
| 1743 | 1 | < 0.1% | |
| 1456 | 1 | < 0.1% | |
| 626 | 1 | < 0.1% | |
| 583 | 1 | < 0.1% | |
| 566 | 1 | < 0.1% |
| Distinct count | 96 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.880368980290082 |
|---|---|
| Minimum | 0 |
| Maximum | 261 |
| Zeros | 29784 |
| Zeros (%) | 22.0% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 3 |
| Q3 | 5 |
| 95-th percentile | 12 |
| Maximum | 261 |
| Range | 261 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 4.780811733 |
|---|---|
| Coefficient of variation (CV) | 1.232050807 |
| Kurtosis | 182.144059 |
| Mean | 3.88036898 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 6.824926588 |
| Sum | 526244 |
| Variance | 22.85616082 |
| Value | Count | Frequency (%) | |
| 0 | 29784 | 22.0% | |
| 2 | 18736 | 13.8% | |
| 1 | 16324 | 12.0% | |
| 3 | 15308 | 11.3% | |
| 4 | 11944 | 8.8% | |
| 5 | 9870 | 7.3% | |
| 6 | 7717 | 5.7% | |
| 7 | 5953 | 4.4% | |
| 8 | 4635 | 3.4% | |
| 9 | 3424 | 2.5% | |
| Other values (86) | 11922 | 8.8% |
| Value | Count | Frequency (%) | |
| 0 | 29784 | 22.0% | |
| 1 | 16324 | 12.0% | |
| 2 | 18736 | 13.8% | |
| 3 | 15308 | 11.3% | |
| 4 | 11944 | 8.8% |
| Value | Count | Frequency (%) | |
| 261 | 1 | < 0.1% | |
| 220 | 1 | < 0.1% | |
| 205 | 1 | < 0.1% | |
| 188 | 1 | < 0.1% | |
| 152 | 1 | < 0.1% |
| Distinct count | 60 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.240220621308538 |
|---|---|
| Minimum | 0 |
| Maximum | 229 |
| Zeros | 29701 |
| Zeros (%) | 21.9% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 3 |
| median | 5 |
| Q3 | 5 |
| 95-th percentile | 9 |
| Maximum | 229 |
| Range | 229 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.237975647 |
|---|---|
| Coefficient of variation (CV) | 0.7636337672 |
| Kurtosis | 263.0151655 |
| Mean | 4.240220621 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 5.581872678 |
| Sum | 575046 |
| Variance | 10.48448629 |
| Value | Count | Frequency (%) | |
| 5 | 53217 | 39.2% | |
| 0 | 29701 | 21.9% | |
| 3 | 17368 | 12.8% | |
| 7 | 10145 | 7.5% | |
| 6 | 8094 | 6.0% | |
| 4 | 4918 | 3.6% | |
| 8 | 3427 | 2.5% | |
| 9 | 2702 | 2.0% | |
| 10 | 1331 | 1.0% | |
| 11 | 1006 | 0.7% | |
| Other values (50) | 3708 | 2.7% |
| Value | Count | Frequency (%) | |
| 0 | 29701 | 21.9% | |
| 1 | 861 | 0.6% | |
| 2 | 382 | 0.3% | |
| 3 | 17368 | 12.8% | |
| 4 | 4918 | 3.6% |
| Value | Count | Frequency (%) | |
| 229 | 1 | < 0.1% | |
| 186 | 1 | < 0.1% | |
| 89 | 1 | < 0.1% | |
| 75 | 1 | < 0.1% | |
| 64 | 1 | < 0.1% |
| Distinct count | 56 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.8185109536415052 |
|---|---|
| Minimum | 0 |
| Maximum | 83 |
| Zeros | 67709 |
| Zeros (%) | 49.9% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 8 |
| Maximum | 83 |
| Range | 83 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 3.271041275 |
|---|---|
| Coefficient of variation (CV) | 1.798747084 |
| Kurtosis | 28.96224513 |
| Mean | 1.818510954 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 3.928269932 |
| Sum | 246621 |
| Variance | 10.69971102 |
| Value | Count | Frequency (%) | |
| 0 | 67709 | 49.9% | |
| 1 | 22326 | 16.5% | |
| 2 | 13774 | 10.2% | |
| 3 | 8853 | 6.5% | |
| 4 | 6036 | 4.5% | |
| 5 | 4157 | 3.1% | |
| 6 | 3037 | 2.2% | |
| 7 | 2144 | 1.6% | |
| 8 | 1602 | 1.2% | |
| 9 | 1269 | 0.9% | |
| Other values (46) | 4710 | 3.5% |
| Value | Count | Frequency (%) | |
| 0 | 67709 | 49.9% | |
| 1 | 22326 | 16.5% | |
| 2 | 13774 | 10.2% | |
| 3 | 8853 | 6.5% | |
| 4 | 6036 | 4.5% |
| Value | Count | Frequency (%) | |
| 83 | 1 | < 0.1% | |
| 74 | 1 | < 0.1% | |
| 70 | 1 | < 0.1% | |
| 67 | 1 | < 0.1% | |
| 66 | 1 | < 0.1% |
| Distinct count | 97 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.884380276808955 |
|---|---|
| Minimum | 0 |
| Maximum | 249 |
| Zeros | 53206 |
| Zeros (%) | 39.2% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 2 |
| Q3 | 8 |
| 95-th percentile | 18 |
| Maximum | 249 |
| Range | 249 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 6.886524556 |
|---|---|
| Coefficient of variation (CV) | 1.409907535 |
| Kurtosis | 31.14887325 |
| Mean | 4.884380277 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.081767771 |
| Sum | 662405 |
| Variance | 47.42422047 |
| Value | Count | Frequency (%) | |
| 0 | 53206 | 39.2% | |
| 1 | 9477 | 7.0% | |
| 2 | 9467 | 7.0% | |
| 3 | 6793 | 5.0% | |
| 4 | 6505 | 4.8% | |
| 6 | 5453 | 4.0% | |
| 5 | 5145 | 3.8% | |
| 7 | 4380 | 3.2% | |
| 8 | 4323 | 3.2% | |
| 9 | 3899 | 2.9% | |
| Other values (87) | 26969 | 19.9% |
| Value | Count | Frequency (%) | |
| 0 | 53206 | 39.2% | |
| 1 | 9477 | 7.0% | |
| 2 | 9467 | 7.0% | |
| 3 | 6793 | 5.0% | |
| 4 | 6505 | 4.8% |
| Value | Count | Frequency (%) | |
| 249 | 1 | < 0.1% | |
| 170 | 1 | < 0.1% | |
| 164 | 1 | < 0.1% | |
| 154 | 1 | < 0.1% | |
| 151 | 1 | < 0.1% |
| Distinct count | 18 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9763746432969318 |
|---|---|
| Minimum | 0 |
| Maximum | 119 |
| Zeros | 29313 |
| Zeros (%) | 21.6% |
| Memory size | 1.0 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 119 |
| Range | 119 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8515156671 |
|---|---|
| Coefficient of variation (CV) | 0.8721198087 |
| Kurtosis | 3746.6939 |
| Mean | 0.9763746433 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 32.21479429 |
| Sum | 132413 |
| Variance | 0.7250789314 |
| Value | Count | Frequency (%) | |
| 1 | 85917 | 63.4% | |
| 0 | 29313 | 21.6% | |
| 2 | 16345 | 12.1% | |
| 3 | 3077 | 2.3% | |
| 4 | 706 | 0.5% | |
| 5 | 194 | 0.1% | |
| 6 | 41 | < 0.1% | |
| 7 | 11 | < 0.1% | |
| 25 | 2 | < 0.1% | |
| 9 | 2 | < 0.1% | |
| Other values (8) | 9 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 29313 | 21.6% | |
| 1 | 85917 | 63.4% | |
| 2 | 16345 | 12.1% | |
| 3 | 3077 | 2.3% | |
| 4 | 706 | 0.5% |
| Value | Count | Frequency (%) | |
| 119 | 1 | < 0.1% | |
| 88 | 1 | < 0.1% | |
| 56 | 1 | < 0.1% | |
| 46 | 1 | < 0.1% | |
| 37 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| user_id | main_home | main_home2 | mainpage | schoolreportpage | main_mime | lightcoursetab | main_learnpark | partnergamebarrierspage | evaulationcenter | coupon_visit | click_buy | progress_bar | ppt | task | video_play | video_read | next_nize | answer_task | chapter_module | course_tab | slide_subscribe | baby_info | click_notunlocked | share | click_dialog | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2000001555945280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 1 | 2000001556645228 | 17 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 5 | 10 | 4 | 7 | 3 | 0 | 0 | 0 | 5 | 0 | 0 | 1 |
| 2 | 2000001558047804 | 5 | 13 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 2 | 5 | 0 | 0 | 1 |
| 3 | 2000001558146467 | 72 | 43 | 8 | 0 | 0 | 3 | 0 | 0 | 3 | 1 | 0 | 46 | 0 | 25 | 28 | 48 | 0 | 20 | 11 | 2 | 9 | 5 | 5 | 7 | 1 |
| 4 | 2000001558146878 | 36 | 28 | 8 | 0 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 25 | 13 | 14 | 17 | 18 | 0 | 14 | 16 | 2 | 3 | 0 | 0 | 1 |
| 5 | 2000001558147371 | 41 | 104 | 9 | 0 | 2 | 4 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 8 | 19 | 2 | 0 | 5 | 0 | 1 |
| 6 | 2000001559045233 | 3 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 7 | 0 | 0 | 1 |
| 7 | 2000001559245920 | 34 | 13 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 16 | 33 | 16 | 7 | 7 | 5 | 0 | 7 | 5 | 0 | 0 | 3 |
| 8 | 2000001559246037 | 31 | 20 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 26 | 15 | 19 | 17 | 22 | 2 | 1 | 1 | 1 | 3 | 0 | 3 | 1 |
| 9 | 2000001559247825 | 88 | 42 | 7 | 2 | 0 | 4 | 5 | 10 | 0 | 0 | 0 | 0 | 40 | 29 | 20 | 41 | 28 | 13 | 9 | 29 | 4 | 7 | 1 | 5 | 1 |
Last rows
| user_id | main_home | main_home2 | mainpage | schoolreportpage | main_mime | lightcoursetab | main_learnpark | partnergamebarrierspage | evaulationcenter | coupon_visit | click_buy | progress_bar | ppt | task | video_play | video_read | next_nize | answer_task | chapter_module | course_tab | slide_subscribe | baby_info | click_notunlocked | share | click_dialog | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 135607 | 2000002947316296 | 0 | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 |
| 135608 | 2000002947316932 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 1 |
| 135609 | 2000002947317071 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 |
| 135610 | 2000002947317483 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 0 | 0 | 1 |
| 135611 | 2000002947317621 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 17 | 0 | 5 | 0 | 0 | 1 |
| 135612 | 2000002947317726 | 1 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 1 | 0 | 0 | 5 | 1 | 0 | 1 |
| 135613 | 2000002947317758 | 0 | 6 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1 |
| 135614 | 2000002947317827 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 135615 | 2000002947317941 | 4 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 0 | 0 | 0 |
| 135616 | 2000002948014779 | 0 | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 3 | 0 | 0 | 1 |